Profiling Report: COVID-19 Data (March-August 2022)

Dataset statistics

Number of variables	16
Number of observations	738944
Missing cells	1103769
Missing cells (%)	9.3%
Duplicate rows	3762
Duplicate rows (%)	0.5%
Total size in memory	95.8 MiB
Average record size in memory	136.0 B

Variable types

Numeric	9
Text	4
DateTime	2
Categorical	1

Alerts

`Recovered` has constant value "0.0"	Constant
Dataset has 3762 (0.5%) duplicate rows	Duplicates
`Active` is highly overall correlated with `Confirmed` and 1 other fields	High correlation
`Confirmed` is highly overall correlated with `Active` and 1 other fields	High correlation
`Deaths` is highly overall correlated with `Active` and 1 other fields	High correlation
`FIPS` has 137632 (18.6%) missing values	Missing
`Admin2` has 136896 (18.5%) missing values	Missing
`Province_State` has 32936 (4.5%) missing values	Missing
`Lat` has 16744 (2.3%) missing values	Missing
`Long_` has 16744 (2.3%) missing values	Missing
`Recovered` has 738000 (99.9%) missing values	Missing
`Incident_Rate` has 17163 (2.3%) missing values	Missing
`Case_Fatality_Ratio` has 7654 (1.0%) missing values	Missing
`Confirmed` is highly skewed (γ1 = 20.47479795)	Skewed
`Active` is highly skewed (γ1 = 20.59259254)	Skewed
`Case_Fatality_Ratio` is highly skewed (γ1 = 69.54895027)	Skewed
`Confirmed` has 7870 (1.1%) zeros	Zeros
`Deaths` has 31811 (4.3%) zeros	Zeros
`Case_Fatality_Ratio` has 25604 (3.5%) zeros	Zeros
`New_Cases` has 16595 (2.2%) zeros	Zeros

Reproduction

Analysis started	2025-11-22 15:51:53.042432
Analysis finished	2025-11-22 15:52:39.700295
Duration	46.66 seconds
Software version	ydata-profiling vv4.18.0
Download configuration	config.json

FIPS
Real number (ℝ)

Missing

Distinct	3268
Distinct (%)	0.5%
Missing	137632
Missing (%)	18.6%
Infinite	0
Infinite (%)	0.0%
Mean	32405.943

Minimum	60
Maximum	99999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.3 MiB

Quantile statistics

Minimum	60
5-th percentile	5095
Q1	19048.5
median	30068
Q3	47041.5
95-th percentile	56011
Maximum	99999
Range	99939
Interquartile range (IQR)	27993

Descriptive statistics

Standard deviation	18053.633
Coefficient of variation (CV)	0.55710871
Kurtosis	0.44724736
Mean	32405.943
Median Absolute Deviation (MAD)	12908
Skewness	0.57375176
Sum	1.9486083 × 10¹⁰
Variance	3.2593368 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
39151	184	< 0.1%
39155	184	< 0.1%
39157	184	< 0.1%
90039	184	< 0.1%
39159	184	< 0.1%
39161	184	< 0.1%
39163	184	< 0.1%
39165	184	< 0.1%
39167	184	< 0.1%
39169	184	< 0.1%
Other values (3258)	599472	81.1%
(Missing)	137632	18.6%

Value	Count	Frequency (%)
60	184	< 0.1%
66	184	< 0.1%
69	184	< 0.1%
78	184	< 0.1%
1001	184	< 0.1%
1003	184	< 0.1%
1005	184	< 0.1%
1007	184	< 0.1%
1009	184	< 0.1%
1011	184	< 0.1%

Value	Count	Frequency (%)
99999	184	< 0.1%
90056	184	< 0.1%
90055	184	< 0.1%
90054	184	< 0.1%
90053	184	< 0.1%
90051	184	< 0.1%
90050	184	< 0.1%
90049	184	< 0.1%
90048	184	< 0.1%
90047	184	< 0.1%

Admin2
Text

Missing

Distinct	1927
Distinct (%)	0.3%
Missing	136896
Missing (%)	18.5%
Memory size	11.3 MiB

Length

Max length	41
Median length	35
Mean length	7.1451711
Min length	3

Characters and Unicode

Total characters	4301736
Distinct characters	57
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Out of ME
2nd row	Out of ME
3rd row	Out of ME
4th row	Out of ME
5th row	Out of ME

Value	Count	Frequency (%)
unassigned	9384	1.4%
washington	5520	0.8%
jefferson	5152	0.8%
franklin	4784	0.7%
st	4784	0.7%
lincoln	4416	0.7%
jackson	4416	0.7%
san	3864	0.6%
madison	3680	0.6%
of	3680	0.6%
Other values (1952)	604992	92.4%

Most occurring characters

Value	Count	Frequency (%)
a	430560	10.0%
e	408664	9.5%
n	365792	8.5%
o	325864	7.6%
r	285200	6.6%
l	238464	5.5%
i	229816	5.3%
s	203504	4.7%
t	191544	4.5%
u	110032	2.6%
Other values (47)	1512296	35.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4301736	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	430560	10.0%
e	408664	9.5%
n	365792	8.5%
o	325864	7.6%
r	285200	6.6%
l	238464	5.5%
i	229816	5.3%
s	203504	4.7%
t	191544	4.5%
u	110032	2.6%
Other values (47)	1512296	35.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4301736	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	430560	10.0%
e	408664	9.5%
n	365792	8.5%
o	325864	7.6%
r	285200	6.6%
l	238464	5.5%
i	229816	5.3%
s	203504	4.7%
t	191544	4.5%
u	110032	2.6%
Other values (47)	1512296	35.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4301736	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	430560	10.0%
e	408664	9.5%
n	365792	8.5%
o	325864	7.6%
r	285200	6.6%
l	238464	5.5%
i	229816	5.3%
s	203504	4.7%
t	191544	4.5%
u	110032	2.6%
Other values (47)	1512296	35.2%

Province_State
Text

Missing

Distinct	598
Distinct (%)	0.1%
Missing	32936
Missing (%)	4.5%
Memory size	11.3 MiB

Length

Max length	44
Median length	32
Mean length	8.5311441
Min length	3

Characters and Unicode

Total characters	6023056
Distinct characters	60
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Australian Capital Territory
2nd row	New South Wales
3rd row	Northern Territory
4th row	Queensland
5th row	South Australia

Value	Count	Frequency (%)
texas	46920	5.5%
virginia	34960	4.1%
georgia	29624	3.5%
north	28704	3.4%
carolina	27232	3.2%
new	24656	2.9%
kentucky	22264	2.6%
dakota	22264	2.6%
missouri	21528	2.5%
south	21344	2.5%
Other values (662)	576656	67.4%

Most occurring characters

Value	Count	Frequency (%)
a	804080	13.4%
i	599472	10.0%
n	483920	8.0%
o	472144	7.8%
s	455216	7.6%
e	362480	6.0%
r	321080	5.3%
t	216936	3.6%
l	207920	3.5%
	150144	2.5%
Other values (50)	1949664	32.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6023056	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	804080	13.4%
i	599472	10.0%
n	483920	8.0%
o	472144	7.8%
s	455216	7.6%
e	362480	6.0%
r	321080	5.3%
t	216936	3.6%
l	207920	3.5%
	150144	2.5%
Other values (50)	1949664	32.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6023056	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	804080	13.4%
i	599472	10.0%
n	483920	8.0%
o	472144	7.8%
s	455216	7.6%
e	362480	6.0%
r	321080	5.3%
t	216936	3.6%
l	207920	3.5%
	150144	2.5%
Other values (50)	1949664	32.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6023056	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	804080	13.4%
i	599472	10.0%
n	483920	8.0%
o	472144	7.8%
s	455216	7.6%
e	362480	6.0%
r	321080	5.3%
t	216936	3.6%
l	207920	3.5%
	150144	2.5%
Other values (50)	1949664	32.4%

Country_Region
Text

Distinct	201
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.3 MiB

Length

Max length	32
Median length	2
Mean length	2.9138446
Min length	2

Characters and Unicode

Total characters	2153168
Distinct characters	60
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Afghanistan
2nd row	Afghanistan
3rd row	Afghanistan
4th row	Afghanistan
5th row	Afghanistan

Value	Count	Frequency (%)
us	603336	80.2%
russia	15272	2.0%
japan	9016	1.2%
india	6808	0.9%
colombia	6256	0.8%
china	6256	0.8%
mexico	6072	0.8%
ukraine	5152	0.7%
brazil	4968	0.7%
peru	4784	0.6%
Other values (225)	84824	11.3%

Most occurring characters

Value	Count	Frequency (%)
S	616216	28.6%
U	612720	28.5%
a	148120	6.9%
i	97704	4.5%
n	77832	3.6%
e	63664	3.0%
s	48944	2.3%
r	41400	1.9%
o	38456	1.8%
l	37904	1.8%
Other values (50)	370208	17.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2153168	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
S	616216	28.6%
U	612720	28.5%
a	148120	6.9%
i	97704	4.5%
n	77832	3.6%
e	63664	3.0%
s	48944	2.3%
r	41400	1.9%
o	38456	1.8%
l	37904	1.8%
Other values (50)	370208	17.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2153168	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
S	616216	28.6%
U	612720	28.5%
a	148120	6.9%
i	97704	4.5%
n	77832	3.6%
e	63664	3.0%
s	48944	2.3%
r	41400	1.9%
o	38456	1.8%
l	37904	1.8%
Other values (50)	370208	17.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2153168	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
S	616216	28.6%
U	612720	28.5%
a	148120	6.9%
i	97704	4.5%
n	77832	3.6%
e	63664	3.0%
s	48944	2.3%
r	41400	1.9%
o	38456	1.8%
l	37904	1.8%
Other values (50)	370208	17.2%

Last_Update
Date

Distinct	205
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.3 MiB

Minimum	2020-08-04 02:27:56
Maximum	2022-09-01 04:21:03
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Lat
Real number (ℝ)

Missing

Distinct	4022
Distinct (%)	0.6%
Missing	16744
Missing (%)	2.3%
Infinite	0
Infinite (%)	0.0%
Mean	35.736183

Minimum	-71.9499
Maximum	71.7069
Zeros	0
Zeros (%)	0.0%
Negative	23184
Negative (%)	3.1%
Memory size	11.3 MiB

Quantile statistics

Minimum	-71.9499
5-th percentile	9.3077
Q1	33.191535
median	37.8957
Q3	42.176955
95-th percentile	49.448196
Maximum	71.7069
Range	143.6568
Interquartile range (IQR)	8.9854206

Descriptive statistics

Standard deviation	13.439624
Coefficient of variation (CV)	0.37607887
Kurtosis	9.7997342
Mean	35.736183
Median Absolute Deviation (MAD)	4.4878388
Skewness	-2.5003793
Sum	25808672
Variance	180.62348
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
52.9399	368	< 0.1%
44.11630765	184	< 0.1%
44.59040891	184	< 0.1%
43.11363907	184	< 0.1%
43.0022601	184	< 0.1%
44.4976179	184	< 0.1%
42.2689144	184	< 0.1%
40.88320119	184	< 0.1%
41.71579493	184	< 0.1%
42.16852837	184	< 0.1%
Other values (4012)	720176	97.5%
(Missing)	16744	2.3%

Value	Count	Frequency (%)
-71.9499	184	< 0.1%
-52.368	184	< 0.1%
-51.7963	184	< 0.1%
-45.9864	184	< 0.1%
-42.8821	184	< 0.1%
-41.9198	184	< 0.1%
-40.9006	184	< 0.1%
-40.231	184	< 0.1%
-38.9489	184	< 0.1%
-38.4161	184	< 0.1%

Value	Count	Frequency (%)
71.7069	184	< 0.1%
70.2998	184	< 0.1%
69.31479216	184	< 0.1%
68.27557185	184	< 0.1%
68.0000418	127	< 0.1%
68.0000418	57	< 0.1%
67.1471631	184	< 0.1%
67.04919196	184	< 0.1%
66.941626	184	< 0.1%
66.8309	184	< 0.1%

Long_
Real number (ℝ)

Missing

Distinct	4075
Distinct (%)	0.6%
Missing	16744
Missing (%)	2.3%
Infinite	0
Infinite (%)	0.0%
Mean	-71.109728

Minimum	-178.1165
Maximum	178.065
Zeros	0
Zeros (%)	0.0%
Negative	634800
Negative (%)	85.9%
Memory size	11.3 MiB

Quantile statistics

Minimum	-178.1165
5-th percentile	-116.47227
Q1	-96.595639
median	-86.717326
Q3	-77.3579
95-th percentile	73.121219
Maximum	178.065
Range	356.1815
Interquartile range (IQR)	19.237739

Descriptive statistics

Standard deviation	55.354465
Coefficient of variation (CV)	-0.7784373
Kurtosis	5.2135408
Mean	-71.109728
Median Absolute Deviation (MAD)	9.628321
Skewness	2.3670982
Sum	-51355446
Variance	3064.1168
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-36.782	368	< 0.1%
-71.5724	368	< 0.1%
-70.812	368	< 0.1%
-73.6536	368	< 0.1%
-74.03	368	< 0.1%
-36.9541	368	< 0.1%
-75.5277	368	< 0.1%
-72.3311	368	< 0.1%
-101.7068	368	< 0.1%
-72.1416	368	< 0.1%
Other values (4065)	718520	97.2%
(Missing)	16744	2.3%

Value	Count	Frequency (%)
-178.1165	184	< 0.1%
-175.1982	184	< 0.1%
-174.1596	184	< 0.1%
-172.1046	184	< 0.1%
-170.132	184	< 0.1%
-169.8672	184	< 0.1%
-168.734	184	< 0.1%
-164.0353804	184	< 0.1%
-163.3967883	57	< 0.1%
-163.3967883	127	< 0.1%

Value	Count	Frequency (%)
178.065	184	< 0.1%
177.6493	184	< 0.1%
174.886	184	< 0.1%
171.1845	184	< 0.1%
169.4900869	184	< 0.1%
166.9592	184	< 0.1%
166.9315	184	< 0.1%
165.618042	184	< 0.1%
160.1562	184	< 0.1%
160.0383819	57	< 0.1%

Confirmed
Real number (ℝ)

High correlation Skewed Zeros

Distinct	132737
Distinct (%)	18.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	132146.92

Minimum	-3073
Maximum	33572631
Zeros	7870
Zeros (%)	1.1%
Negative	2
Negative (%)	< 0.1%
Memory size	11.3 MiB

Quantile statistics

Minimum	-3073
5-th percentile	532
Q1	3119
median	8807
Q3	38301.25
95-th percentile	445952
Maximum	33572631
Range	33575704
Interquartile range (IQR)	35182.25

Descriptive statistics

Standard deviation	816837.97
Coefficient of variation (CV)	6.1812865
Kurtosis	578.54552
Mean	132146.92
Median Absolute Deviation (MAD)	7274.5
Skewness	20.474798
Sum	9.7649172 × 10¹⁰
Variance	6.6722426 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7870	1.1%
1	409	0.1%
13	387	0.1%
535	272	< 0.1%
434	259	< 0.1%
8	257	< 0.1%
9	248	< 0.1%
103	243	< 0.1%
100	236	< 0.1%
712	232	< 0.1%
Other values (132727)	728531	98.6%

Value	Count	Frequency (%)
-3073	2	< 0.1%
0	7870	1.1%
1	409	0.1%
2	25	< 0.1%
3	133	< 0.1%
4	232	< 0.1%
5	57	< 0.1%
6	37	< 0.1%
7	129	< 0.1%
8	257	< 0.1%

Value	Count	Frequency (%)
33572631	1	< 0.1%
33553391	1	< 0.1%
33529669	1	< 0.1%
33493920	3	< 0.1%
33481790	1	< 0.1%
33461953	1	< 0.1%
33440664	1	< 0.1%
33411676	1	< 0.1%
33372974	3	< 0.1%
33357883	1	< 0.1%

Deaths
Real number (ℝ)

High correlation Zeros

Distinct	20227
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1568.8279

Minimum	-82
Maximum	175530
Zeros	31811
Zeros (%)	4.3%
Negative	2
Negative (%)	< 0.1%
Memory size	11.3 MiB

Quantile statistics

Minimum	-82
5-th percentile	2
Q1	41
median	118
Q3	410
95-th percentile	6324
Maximum	175530
Range	175612
Interquartile range (IQR)	369

Descriptive statistics

Standard deviation	8330.0068
Coefficient of variation (CV)	5.3097008
Kurtosis	215.80612
Mean	1568.8279
Median Absolute Deviation (MAD)	98
Skewness	13.298687
Sum	1.159276 × 10⁹
Variance	69389013
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	31811	4.3%
12	5903	0.8%
9	5299	0.7%
2	4885	0.7%
20	4740	0.6%
3	4739	0.6%
7	4708	0.6%
1	4648	0.6%
6	4569	0.6%
11	4513	0.6%
Other values (20217)	663129	89.7%

Value	Count	Frequency (%)
-82	2	< 0.1%
0	31811	4.3%
1	4648	0.6%
2	4885	0.7%
3	4739	0.6%
4	2650	0.4%
5	3056	0.4%
6	4569	0.6%
7	4708	0.6%
8	4471	0.6%

Value	Count	Frequency (%)
175530	1	< 0.1%
175474	1	< 0.1%
175439	1	< 0.1%
175395	1	< 0.1%
175341	1	< 0.1%
175289	1	< 0.1%
175256	1	< 0.1%
175215	1	< 0.1%
175174	1	< 0.1%
175110	1	< 0.1%

Recovered
Categorical

Constant Missing

Distinct	1
Distinct (%)	0.1%
Missing	738000
Missing (%)	99.9%
Memory size	11.3 MiB

0.0	944

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	2832
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	944	0.1%
(Missing)	738000	99.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	944	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	1888	66.7%
.	944	33.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2832	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	1888	66.7%
.	944	33.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2832	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	1888	66.7%
.	944	33.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2832	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	1888	66.7%
.	944	33.3%

Active
Real number (ℝ)

High correlation Skewed

Distinct	134226
Distinct (%)	18.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	130578.09

Minimum	-4531
Maximum	33422002
Zeros	6454
Zeros (%)	0.9%
Negative	1794
Negative (%)	0.2%
Memory size	11.3 MiB

Quantile statistics

Minimum	-4531
5-th percentile	521
Q1	3071
median	8672
Q3	37652
95-th percentile	440409
Maximum	33422002
Range	33426533
Interquartile range (IQR)	34581

Descriptive statistics

Standard deviation	810441.62
Coefficient of variation (CV)	6.2065666
Kurtosis	584.62648
Mean	130578.09
Median Absolute Deviation (MAD)	7173
Skewness	20.592593
Sum	9.6489896 × 10¹⁰
Variance	6.5681562 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6454	0.9%
13	387	0.1%
7	313	< 0.1%
1	299	< 0.1%
-5	295	< 0.1%
100	291	< 0.1%
699	280	< 0.1%
434	276	< 0.1%
8	257	< 0.1%
122	239	< 0.1%
Other values (134216)	729853	98.8%

Value	Count	Frequency (%)
-4531	1	< 0.1%
-4529	1	< 0.1%
-4527	1	< 0.1%
-4517	3	< 0.1%
-4506	1	< 0.1%
-4505	2	< 0.1%
-4499	1	< 0.1%
-4477	3	< 0.1%
-4476	1	< 0.1%
-4474	1	< 0.1%

Value	Count	Frequency (%)
33422002	1	< 0.1%
33402816	1	< 0.1%
33379145	1	< 0.1%
33343506	3	< 0.1%
33331421	1	< 0.1%
33311628	1	< 0.1%
33290396	1	< 0.1%
33261496	1	< 0.1%
33222910	3	< 0.1%
33207891	1	< 0.1%

Combined_Key
Text

Distinct	4016
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	11.3 MiB

Length

Max length	60
Median length	45
Mean length	20.426295
Min length	4

Characters and Unicode

Total characters	15093888
Distinct characters	62
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Afghanistan
2nd row	Afghanistan
3rd row	Afghanistan
4th row	Afghanistan
5th row	Afghanistan

Value	Count	Frequency (%)
us	603336	26.7%
texas	47288	2.1%
virginia	35144	1.6%
georgia	29808	1.3%
north	29440	1.3%
carolina	27416	1.2%
new	26680	1.2%
dakota	22632	1.0%
kentucky	22264	1.0%
south	21896	1.0%
Other values (2758)	1397480	61.7%

Most occurring characters

Value	Count	Frequency (%)
	1524440	10.1%
a	1382760	9.2%
,	1308792	8.7%
n	927544	6.1%
i	926992	6.1%
o	836464	5.5%
e	834808	5.5%
s	707664	4.7%
S	702512	4.7%
r	647680	4.3%
Other values (52)	5294232	35.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	15093888	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	1524440	10.1%
a	1382760	9.2%
,	1308792	8.7%
n	927544	6.1%
i	926992	6.1%
o	836464	5.5%
e	834808	5.5%
s	707664	4.7%
S	702512	4.7%
r	647680	4.3%
Other values (52)	5294232	35.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	15093888	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	1524440	10.1%
a	1382760	9.2%
,	1308792	8.7%
n	927544	6.1%
i	926992	6.1%
o	836464	5.5%
e	834808	5.5%
s	707664	4.7%
S	702512	4.7%
r	647680	4.3%
Other values (52)	5294232	35.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	15093888	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	1524440	10.1%
a	1382760	9.2%
,	1308792	8.7%
n	927544	6.1%
i	926992	6.1%
o	836464	5.5%
e	834808	5.5%
s	707664	4.7%
S	702512	4.7%
r	647680	4.3%
Other values (52)	5294232	35.1%

Incident_Rate
Real number (ℝ)

Missing

Distinct	297730
Distinct (%)	41.2%
Missing	17163
Missing (%)	2.3%
Infinite	0
Infinite (%)	0.0%
Mean	23362.236

Minimum	0
Maximum	1239511.5
Zeros	1499
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	11.3 MiB

Quantile statistics

Minimum	0
5-th percentile	4591.0632
Q1	19679.157
median	24423.797
Q3	28372.877
95-th percentile	34957.168
Maximum	1239511.5
Range	1239511.5
Interquartile range (IQR)	8693.7191

Descriptive statistics

Standard deviation	9024.5535
Coefficient of variation (CV)	0.38628809
Kurtosis	471.01544
Mean	23362.236
Median Absolute Deviation (MAD)	4298.3536
Skewness	3.7387476
Sum	1.6862418 × 10¹⁰
Variance	81442567
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1499	0.2%
1.773255814	184	< 0.1%
186.4821515	184	< 0.1%
12548.1111	184	< 0.1%
12852.68405	184	< 0.1%
13575.48508	184	< 0.1%
12753.90455	184	< 0.1%
9603.023339	184	< 0.1%
13994.25746	184	< 0.1%
16854.53728	184	< 0.1%
Other values (297720)	718626	97.3%
(Missing)	17163	2.3%

Value	Count	Frequency (%)
0	1499	0.2%
0.003879154259	109	< 0.1%
0.02906976744	161	< 0.1%
0.05813953488	1	< 0.1%
0.3488372093	1	< 0.1%
0.4069767442	3	< 0.1%
0.45	11	< 0.1%
0.4555555556	2	< 0.1%
0.4611111111	1	< 0.1%
0.4666666667	1	< 0.1%

Value	Count	Frequency (%)
1239511.494	1	< 0.1%
343404.6346	2	< 0.1%
190532.5444	1	< 0.1%
189940.8284	1	< 0.1%
189349.1124	1	< 0.1%
188757.3964	3	< 0.1%
188165.6805	4	< 0.1%
186390.5325	5	< 0.1%
185798.8166	2	< 0.1%
184023.6686	3	< 0.1%

Case_Fatality_Ratio
Real number (ℝ)

Missing Skewed Zeros

Distinct	252733
Distinct (%)	34.6%
Missing	7654
Missing (%)	1.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.6008515

Minimum	0
Maximum	6200
Zeros	25604
Zeros (%)	3.5%
Negative	0
Negative (%)	0.0%
Memory size	11.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.15698358
Q1	0.91806847
median	1.3661972
Q3	1.8613861
95-th percentile	2.9942879
Maximum	6200
Range	6200
Interquartile range (IQR)	0.94331767

Descriptive statistics

Standard deviation	62.783077
Coefficient of variation (CV)	24.139432
Kurtosis	5162.8193
Mean	2.6008515
Median Absolute Deviation (MAD)	0.46957271
Skewness	69.54895
Sum	1901976.7
Variance	3941.7148
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	25604	3.5%
1.136363636	293	< 0.1%
2.857142857	287	< 0.1%
2.083333333	232	< 0.1%
1.234567901	230	< 0.1%
1.587301587	230	< 0.1%
1.449275362	218	< 0.1%
2.040816327	217	< 0.1%
2.912621359	213	< 0.1%
1.162790698	199	< 0.1%
Other values (252723)	703567	95.2%
(Missing)	7654	1.0%

Value	Count	Frequency (%)
0	25604	3.5%
0.000424006394	1	< 0.1%
0.002962295898	7	< 0.1%
0.002977501995	7	< 0.1%
0.00299263214	7	< 0.1%
0.003009600626	7	< 0.1%
0.003027165786	7	< 0.1%
0.003047554033	7	< 0.1%
0.003071951242	7	< 0.1%
0.003086457858	6	< 0.1%

Value	Count	Frequency (%)
6200	1	< 0.1%
5848.684211	1	< 0.1%
5761.25	1	< 0.1%
5619.753086	1	< 0.1%
5600	1	< 0.1%
5554.216867	1	< 0.1%
5541.772152	1	< 0.1%
5539.74359	1	< 0.1%
5530.379747	1	< 0.1%
5430.588235	1	< 0.1%

New_Cases
Real number (ℝ)

Zeros

Distinct	167261
Distinct (%)	22.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	138.80376

Minimum	-33459805
Maximum	33571870
Zeros	16595
Zeros (%)	2.2%
Negative	353831
Negative (%)	47.9%
Memory size	11.3 MiB

Quantile statistics

Minimum	-33459805
5-th percentile	-164942.25
Q1	-9177
median	0
Q3	8690
95-th percentile	166812.4
Maximum	33571870
Range	67031675
Interquartile range (IQR)	17867

Descriptive statistics

Standard deviation	859090.05
Coefficient of variation (CV)	6189.2419
Kurtosis	785.72439
Mean	138.80376
Median Absolute Deviation (MAD)	9007
Skewness	-0.014805279
Sum	1.0256821 × 10⁸
Variance	7.3803571 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	16595	2.2%
1	476	0.1%
2	404	0.1%
13	376	0.1%
3	346	< 0.1%
4	308	< 0.1%
54	292	< 0.1%
5	262	< 0.1%
6	257	< 0.1%
7	246	< 0.1%
Other values (167251)	719382	97.4%

Value	Count	Frequency (%)
-33459805	1	< 0.1%
-33436083	1	< 0.1%
-33400334	3	< 0.1%
-33388204	1	< 0.1%
-33368533	1	< 0.1%
-33347244	1	< 0.1%
-33318256	1	< 0.1%
-33279554	3	< 0.1%
-33264463	1	< 0.1%
-33241001	1	< 0.1%

Value	Count	Frequency (%)
33571870	1	< 0.1%
33552630	1	< 0.1%
33528908	1	< 0.1%
33493159	3	< 0.1%
33481029	1	< 0.1%
33461192	1	< 0.1%
33439903	1	< 0.1%
33410915	1	< 0.1%
33372213	3	< 0.1%
33357122	1	< 0.1%

Date
Date

Distinct	192
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.3 MiB

Minimum	2020-08-04 00:00:00
Maximum	2022-09-01 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

	Active	Case_Fatality_Ratio	Confirmed	Deaths	FIPS	Incident_Rate	Lat	Long_	New_Cases
Active	1.000	-0.197	1.000	0.903	-0.063	-0.016	-0.081	0.474	0.421
Case_Fatality_Ratio	-0.197	1.000	-0.193	0.127	-0.070	-0.138	-0.166	-0.134	-0.138
Confirmed	1.000	-0.193	1.000	0.905	-0.063	-0.016	-0.082	0.474	0.421
Deaths	0.903	0.127	0.905	1.000	-0.126	-0.044	-0.115	0.390	0.384
FIPS	-0.063	-0.070	-0.063	-0.126	1.000	-0.098	0.022	0.134	-0.015
Incident_Rate	-0.016	-0.138	-0.016	-0.044	-0.098	1.000	0.117	-0.205	0.101
Lat	-0.081	-0.166	-0.082	-0.115	0.022	0.117	1.000	-0.173	0.009
Long_	0.474	-0.134	0.474	0.390	0.134	-0.205	-0.173	1.000	0.033
New_Cases	0.421	-0.138	0.421	0.384	-0.015	0.101	0.009	0.033	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	FIPS	Admin2	Province_State	Country_Region	Last_Update	Lat	Long_	Confirmed	Deaths	Recovered	Active	Combined_Key	Incident_Rate	Case_Fatality_Ratio	New_Cases	Date
0	NaN	NaN	NaN	Afghanistan	2022-03-02 04:21:07	33.93911	67.709953	173879	7609	NaN	166270.0	Afghanistan	446.664295	4.376032	0.0	2022-03-02
4016	NaN	NaN	NaN	Afghanistan	2022-03-03 04:21:01	33.93911	67.709953	174073	7617	NaN	166456.0	Afghanistan	447.162647	4.375750	194.0	2022-03-03
8032	NaN	NaN	NaN	Afghanistan	2022-03-04 04:21:09	33.93911	67.709953	174214	7619	NaN	166595.0	Afghanistan	447.524851	4.373357	141.0	2022-03-04
12048	NaN	NaN	NaN	Afghanistan	2022-03-05 04:21:10	33.93911	67.709953	174214	7619	NaN	166595.0	Afghanistan	447.524851	4.373357	0.0	2022-03-05
16064	NaN	NaN	NaN	Afghanistan	2022-03-06 04:20:49	33.93911	67.709953	174331	7622	NaN	166709.0	Afghanistan	447.825403	4.372143	117.0	2022-03-06
20080	NaN	NaN	NaN	Afghanistan	2022-03-07 04:20:47	33.93911	67.709953	174582	7623	NaN	166959.0	Afghanistan	448.470178	4.366430	251.0	2022-03-07
24096	NaN	NaN	NaN	Afghanistan	2022-03-08 04:20:54	33.93911	67.709953	175000	7626	NaN	167374.0	Afghanistan	449.543945	4.357714	418.0	2022-03-08
28112	NaN	NaN	NaN	Afghanistan	2022-03-09 04:20:59	33.93911	67.709953	175353	7630	NaN	167723.0	Afghanistan	450.450740	4.351223	353.0	2022-03-09
32128	NaN	NaN	NaN	Afghanistan	2022-03-10 04:20:48	33.93911	67.709953	175525	7636	NaN	167889.0	Afghanistan	450.892577	4.350377	172.0	2022-03-10
36144	NaN	NaN	NaN	Afghanistan	2022-03-11 04:20:50	33.93911	67.709953	175893	7639	NaN	168254.0	Afghanistan	451.837904	4.342981	368.0	2022-03-11

	FIPS	Admin2	Province_State	Country_Region	Last_Update	Lat	Long_	Confirmed	Deaths	Recovered	Active	Combined_Key	Incident_Rate	Case_Fatality_Ratio	New_Cases	Date
702795	NaN	NaN	NaN	Zimbabwe	2022-08-23 04:20:56	-19.015438	29.154857	256628	5592	NaN	251036.0	Zimbabwe	1726.631639	2.179030	4.0	2022-08-23
706811	NaN	NaN	NaN	Zimbabwe	2022-08-24 04:20:46	-19.015438	29.154857	256628	5592	NaN	251036.0	Zimbabwe	1726.631639	2.179030	0.0	2022-08-24
710827	NaN	NaN	NaN	Zimbabwe	2022-08-25 04:21:13	-19.015438	29.154857	256628	5592	NaN	251036.0	Zimbabwe	1726.631639	2.179030	0.0	2022-08-25
714843	NaN	NaN	NaN	Zimbabwe	2022-08-26 04:21:02	-19.015438	29.154857	256675	5593	NaN	251082.0	Zimbabwe	1726.947862	2.179020	47.0	2022-08-26
718859	NaN	NaN	NaN	Zimbabwe	2022-08-27 04:20:57	-19.015438	29.154857	256682	5593	NaN	251089.0	Zimbabwe	1726.994959	2.178961	7.0	2022-08-27
722875	NaN	NaN	NaN	Zimbabwe	2022-08-28 04:21:02	-19.015438	29.154857	256682	5593	NaN	251089.0	Zimbabwe	1726.994959	2.178961	0.0	2022-08-28
726891	NaN	NaN	NaN	Zimbabwe	2022-08-29 04:21:06	-19.015438	29.154857	256699	5593	NaN	251106.0	Zimbabwe	1727.109337	2.178816	17.0	2022-08-29
730907	NaN	NaN	NaN	Zimbabwe	2022-08-30 04:21:03	-19.015438	29.154857	256704	5593	NaN	251111.0	Zimbabwe	1727.142978	2.178774	5.0	2022-08-30
734923	NaN	NaN	NaN	Zimbabwe	2022-08-31 04:20:57	-19.015438	29.154857	256708	5593	NaN	251115.0	Zimbabwe	1727.169891	2.178740	4.0	2022-08-31
738939	NaN	NaN	NaN	Zimbabwe	2022-09-01 04:21:03	-19.015438	29.154857	256726	5596	NaN	251130.0	Zimbabwe	1727.290997	2.179756	18.0	2022-09-01

Most frequently occurring

	FIPS	Admin2	Province_State	Country_Region	Last_Update	Lat	Long_	Confirmed	Deaths	Recovered	Active	Combined_Key	Incident_Rate	Case_Fatality_Ratio	New_Cases	Date	# duplicates
2957	80001.0	Out of AL	Alabama	US	2020-12-21 13:27:30	NaN	NaN	0	0	NaN	0.0	Out of AL, Alabama, US	NaN	NaN	0.0	2020-12-21	184
2969	90001.0	Unassigned	Alabama	US	2020-12-21 13:27:30	NaN	NaN	0	0	NaN	0.0	Unassigned, Alabama, US	NaN	NaN	0.0	2020-12-21	184
3033	90051.0	Unassigned	Virginia	US	2020-12-21 13:27:30	NaN	NaN	0	0	NaN	0.0	Unassigned, Virginia, US	NaN	NaN	0.0	2020-12-21	184
3038	99999.0	NaN	Grand Princess	US	2020-08-04 02:27:56	NaN	NaN	103	3	NaN	100.0	Grand Princess, US	NaN	2.912621	54.0	2020-08-04	184
3177	NaN	NaN	Grand Princess	Canada	2020-12-21 13:27:30	NaN	NaN	13	0	NaN	13.0	Grand Princess, Canada	NaN	0.000000	13.0	2020-12-21	184
2955	72888.0	Out of PR	Puerto Rico	US	2021-10-10 23:21:42	NaN	NaN	434	0	NaN	434.0	Out of PR, Puerto Rico, US	NaN	0.000000	0.0	2021-10-10	183
2964	80023.0	Out of ME	Maine	US	2020-08-07 22:34:20	NaN	NaN	0	0	NaN	0.0	Out of ME, Maine, US	NaN	NaN	0.0	2020-08-07	183
2968	88888.0	NaN	Diamond Princess	US	2020-08-04 02:27:56	NaN	NaN	49	0	NaN	49.0	Diamond Princess, US	NaN	0.000000	-54.0	2020-08-04	183
3035	90054.0	Unassigned	West Virginia	US	2021-07-31 23:21:38	NaN	NaN	0	0	NaN	0.0	Unassigned, West Virginia, US	NaN	NaN	0.0	2021-07-31	183
3149	NaN	NaN	Diamond Princess	Canada	2020-12-21 13:27:30	NaN	NaN	0	1	NaN	-1.0	Diamond Princess, Canada	NaN	NaN	-13.0	2020-12-21	183

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring